1 -- phpMyAdmin SQL Dump
2 -- version 4.6.5.2
3 -- https://www.phpmyadmin.net/
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jul 11, 2018 at 09:52 AM
7 -- Server version: 10.1.21-MariaDB
8 -- PHP Version: 7.1.1
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8mb4 */;
18
19 --
20 -- Database: `vehicle management`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `admin`
27 --
28
29 CREATE TABLE `admin` (
30 `admin_id` int(11) NOT NULL,
31 `username` varchar(100) NOT NULL,
32 `password` varchar(100) NOT NULL
33 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35 --
36 -- Dumping data for table `admin`
37 --
38
39 INSERT INTO `admin` (`admin_id`, `username`, `password`) VALUES
40 (1, 'mihaf24', '1234');
41
42 -- --------------------------------------------------------
43
44 --
45 -- Table structure for table `bill`
46 --
47
48 CREATE TABLE `bill` (
49 `bill_id` int(11) NOT NULL,
50 `id` varchar(255) NOT NULL,
51 `username` varchar(100) NOT NULL,
52 `salary` int(255) NOT NULL,
53 `equipment` int(255) NOT NULL,
54 `oil` int(255) NOT NULL,
55 `tcost` int(255) NOT NULL
56 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58 --
59 -- Dumping data for table `bill`
60 --
61
62 INSERT INTO `bill` (`bill_id`, `id`, `username`, `salary`, `equipment`, `oil`, `tcost`) VALUES
63 (8, '25', '', 1000, 1000001, 1010, 101010101),
64 (9, '25', '', 1000, 100, 300, 1400),
65 (10, '25', '', 10000, 500, 4000, 10000);
66
67 -- --------------------------------------------------------
68
69 --
70 -- Table structure for table `booking`
71 --
72
73 CREATE TABLE `booking` (
74 `booking_id` int(11) NOT NULL,
75 `name` varchar(255) NOT NULL,
76 `username` varchar(100) NOT NULL,
77 `department` varchar(100) NOT NULL,
78 `type` varchar(8) NOT NULL,
79 `req_date` varchar(100) NOT NULL,
80 `req_time` varchar(100) NOT NULL,
81 `ret_date` varchar(100) NOT NULL,
82 `ret_time` varchar(100) NOT NULL,
83 `destination` varchar(100) NOT NULL,
84 `pickup_point` varchar(100) NOT NULL,
85 `resons` varchar(255) NOT NULL,
86 `email` varchar(50) NOT NULL,
87 `mobile` int(14) NOT NULL,
88 `confirmation` int(11) NOT NULL,
89 `veh_reg` varchar(255) NOT NULL,
90 `driverid` int(11) NOT NULL,
91 `finished` int(11) NOT NULL,
92 `paid` int(11) NOT NULL
93 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
94
95 --
96 -- Dumping data for table `booking`
97 --
98
99 INSERT INTO `booking` (`booking_id`, `name`, `username`, `department`, `type`, `req_date`, `req_time`, `ret_date`, `ret_time`, `destination`, `pickup_point`, `resons`, `email`, `mobile`, `confirmation`, `veh_reg`, `driverid`, `finished`, `paid`) VALUES
100 (47, 'ibtihaj ahmed', 'fahad', 'CSE', 'car', '05/01/2018', '7 : 19 AM', '05/02/2018', '7 : 19 AM', 'Katakhali', 'Ruet Gate', 'Education', 'fahad@gmail.com', 19398134, 1, 'ga-259723', 20, 1, 1),
101 (48, 'ibtihaj ahmed', 'fahad', 'CSE', 'car', '05/01/2018', '7 : 22 AM', '05/02/2018', '7 : 22 AM', 'dd', 'dd', 'dd', 'fahad@gmail.com', 19398134, 1, 'cho- 301294', 20, 1, 1),
102 (49, 'ibtihaj ahmed', 'fahad', 'CSE', 'car', '05/24/2018', '7 : 32 AM', '05/25/2018', '7 : 32 AM', 'ra', 'as', 'Trip', 'fahad@gmail.com', 2147483647, 1, 'cho- 301294', 21, 1, 1),
103 (50, 'ibtihaj ahmed', 'fahad', 'cse', 'car', '07/09/2018', '8 : 55 PM', '07/10/2018', '8 : 55 PM', 'kajla', 'kajla', 'emni', 'fahad@gmail.com', 2147483647, 1, 'ga-259723', 20, 1, 1),
104 (51, 'ibtihaj ahmed', 'fahad', 'dd', 'car', '07/09/2018', '9 : 05 PM', '07/09/2018', '9 : 05 PM', 'dd', 'dd', 'dd', 'fahad@gmail.com', 0, 1, 'cho- 301294', 21, 1, 1),
105 (52, 'ibtihaj ahmed', 'fahad', 'dd', 'car', '07/02/2018', '9 : 06 PM', '07/02/2018', '9 : 06 PM', 'dd', 'dd', 'sd', 'fahad@gmail.com', 0, 1, 'cho- 301294', 21, 1, 1),
106 (53, 'ibtihaj ahmed', 'fahad', 'cse', 'bus', '07/09/2018', '9 : 11 PM', '07/08/2018', '9 : 11 PM', 'ddd', 'ddd', 'dd', 'fahad@gmail.com', 1738718731, 1, 'ga-259723', 20, 0, 0);
107
108 -- --------------------------------------------------------
109
110 --
111 -- Table structure for table `driver`
112 --
113
114 CREATE TABLE `driver` (
115 `driverid` int(11) NOT NULL,
116 `drname` varchar(255) NOT NULL,
117 `drjoin` varchar(255) NOT NULL,
118 `drmobile` varchar(20) NOT NULL,
119 `drnid` varchar(30) NOT NULL,
120 `drlicense` varchar(30) NOT NULL,
121 `drlicensevalid` varchar(100) NOT NULL,
122 `draddress` varchar(255) NOT NULL,
123 `drphoto` varchar(30) NOT NULL,
124 `dr_available` int(11) NOT NULL
125 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127 --
128 -- Dumping data for table `driver`
129 --
130
131 INSERT INTO `driver` (`driverid`, `drname`, `drjoin`, `drmobile`, `drnid`, `drlicense`, `drlicensevalid`, `draddress`, `drphoto`, `dr_available`) VALUES
132 (20, 'fahim', '03/04/2018', '01717172398712', '91238912093097812', '1093q098091839', '03/26/2018', ' creasent road, dhaka, bangladesh.', 'nsf.jpg', 1),
133 (21, 'Arman', '03/04/2018', '0123084982', 'kls3893809839082', '1093q098091839', '03/04/2018', ' Oktroy Mor, Rajshahi.', 'rkb.jpg', 0);
134
135 -- --------------------------------------------------------
136
137 --
138 -- Table structure for table `tripcost`
139 --
140
141 CREATE TABLE `tripcost` (
142 `id` int(11) NOT NULL,
143 `booking_id` varchar(50) NOT NULL,
144 `username` varchar(100) NOT NULL,
145 `total_km` varchar(11) NOT NULL,
146 `oil_cost` varchar(11) NOT NULL,
147 `extra_cost` varchar(11) NOT NULL,
148 `total_cost` varchar(11) NOT NULL,
149 `paid` int(11) NOT NULL
150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151
152 --
153 -- Dumping data for table `tripcost`
154 --
155
156 INSERT INTO `tripcost` (`id`, `booking_id`, `username`, `total_km`, `oil_cost`, `extra_cost`, `total_cost`, `paid`) VALUES
157 (13, '47', 'fahad', '10', '33', '8', '250', 1),
158 (15, '48', 'fahad', '10', '1000', '1200', '2200', 1),
159 (18, '49', 'fahad', '8', '1000', '1200', '2200', 1),
160 (19, '51', 'fahad', '100', '100`', '10', '10', 1),
161 (20, '52', 'fahad', '10', '1000', '10', '1010', 1);
162
163 -- --------------------------------------------------------
164
165 --
166 -- Table structure for table `user`
167 --
168
169 CREATE TABLE `user` (
170 `user_id` int(11) NOT NULL,
171 `first_name` varchar(255) NOT NULL,
172 `last_name` varchar(255) NOT NULL,
173 `email` varchar(255) NOT NULL,
174 `username` varchar(255) NOT NULL,
175 `password` varchar(255) NOT NULL,
176 `admin` int(11) NOT NULL
177 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178
179 --
180 -- Dumping data for table `user`
181 --
182
183 INSERT INTO `user` (`user_id`, `first_name`, `last_name`, `email`, `username`, `password`, `admin`) VALUES
184 (10, 'ibtihaj', 'ahmed', 'fahad@gmail.com', 'fahad', 'asdasd', 0),
185 (13, 'dad', 'ahmed', 'fahaha@gmail.com', 'asdasd', 'asdasdad', 0),
186 (14, 'rakibul', 'hoque', 'rakib@gmail.com', 'rakib24', '1234', 0);
187
188 -- --------------------------------------------------------
189
190 --
191 -- Table structure for table `vehicle`
192 --
193
194 CREATE TABLE `vehicle` (
195 `veh_id` int(11) NOT NULL,
196 `veh_reg` varchar(100) NOT NULL,
197 `veh_type` varchar(20) NOT NULL,
198 `chesisno` varchar(100) NOT NULL,
199 `brand` varchar(100) NOT NULL,
200 `veh_color` varchar(100) NOT NULL,
201 `veh_regdate` varchar(100) NOT NULL,
202 `veh_description` varchar(255) NOT NULL,
203 `veh_photo` varchar(255) NOT NULL,
204 `veh_available` int(11) NOT NULL
205 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
206
207 --
208 -- Dumping data for table `vehicle`
209 --
210
211 INSERT INTO `vehicle` (`veh_id`, `veh_reg`, `veh_type`, `chesisno`, `brand`, `veh_color`, `veh_regdate`, `veh_description`, `veh_photo`, `veh_available`) VALUES
212 (25, 'ga-259723', 'car', '101-12303.20201', 'corolla', 'Black', '25/03.17', 'hello this is a black car.', '1.jpg', 1),
213 (26, 'cho- 301294', 'car', '101-12309.23981', 'axio', 'white', '26.9.15', ' hello this is a white car. ', '2.jpg', 0),
214 (35, 'go-190312', 'car', '101321-138713.3291823', 'Corolla', 'Red', '10/17/2017', ' This is a red car.', 'images.jpg', 1);
215
216 --
217 -- Indexes for dumped tables
218 --
219
220 --
221 -- Indexes for table `admin`
222 --
223 ALTER TABLE `admin`
224 ADD PRIMARY KEY (`admin_id`);
225
226 --
227 -- Indexes for table `bill`
228 --
229 ALTER TABLE `bill`
230 ADD PRIMARY KEY (`bill_id`);
231
232 --
233 -- Indexes for table `booking`
234 --
235 ALTER TABLE `booking`
236 ADD PRIMARY KEY (`booking_id`);
237
238 --
239 -- Indexes for table `driver`
240 --
241 ALTER TABLE `driver`
242 ADD PRIMARY KEY (`driverid`);
243
244 --
245 -- Indexes for table `tripcost`
246 --
247 ALTER TABLE `tripcost`
248 ADD PRIMARY KEY (`id`);
249
250 --
251 -- Indexes for table `user`
252 --
253 ALTER TABLE `user`
254 ADD PRIMARY KEY (`user_id`);
255
256 --
257 -- Indexes for table `vehicle`
258 --
259 ALTER TABLE `vehicle`
260 ADD PRIMARY KEY (`veh_id`);
261
262 --
263 -- AUTO_INCREMENT for dumped tables
264 --
265
266 --
267 -- AUTO_INCREMENT for table `admin`
268 --
269 ALTER TABLE `admin`
270 MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
271 --
272 -- AUTO_INCREMENT for table `bill`
273 --
274 ALTER TABLE `bill`
275 MODIFY `bill_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
276 --
277 -- AUTO_INCREMENT for table `booking`
278 --
279 ALTER TABLE `booking`
280 MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
281 --
282 -- AUTO_INCREMENT for table `driver`
283 --
284 ALTER TABLE `driver`
285 MODIFY `driverid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
286 --
287 -- AUTO_INCREMENT for table `tripcost`
288 --
289 ALTER TABLE `tripcost`
290 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
291 --
292 -- AUTO_INCREMENT for table `user`
293 --
294 ALTER TABLE `user`
295 MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
296 --
297 -- AUTO_INCREMENT for table `vehicle`
298 --
299 ALTER TABLE `vehicle`
300 MODIFY `veh_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
301 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
302 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
303 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;